<FileStats>
<FilesList>
<FileLine Name='daily.bat' Path='H-Drive\Bat_Cis\RUN' Size='     9,140' Date='2008-06-02   18:01' />
<FileLine Name='INITGLOBALS.BAT' Path='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\INCLUDE' Size='       724' Date='2008-06-02   18:14' />
<FileLine Name='SUNITED.bat' Path='H-Drive\Bat_Cis\RUN' Size='     5,605' Date='2008-06-02   18:01' />
<FileLine Name='SUTRPL.BAT' Path='H-Drive\Bat_Cis\RUN' Size='     1,089' Date='2008-06-02   18:01' />
<FileLine Name='SUUP11R.PCO' Path='L-Drive\COB_2000\COMPILE\SOURCE' Size='    72,167' Date='2008-06-02   18:19' />
<FileLine Name='SUUP11R.EXE' Path='H-Drive\Bat_Cis\RUN\BIN\' Size='          ' Date='0001-01-01   00:00' />
<FileLine Name='SUIADJ.BAT' Path='H-Drive\Bat_Cis\RUN' Size='     1,815' Date='2008-06-02   18:01' />
<FileLine Name='SUUP03R.PCO' Path='L-Drive\COB_2000\COMPILE\SOURCE' Size='    99,167' Date='2008-06-02   18:19' />
<FileLine Name='SUUP03R.EXE' Path='H-Drive\Bat_Cis\RUN\BIN\' Size='          ' Date='0001-01-01   00:00' />
<FileLine Name='SUIYTD.BAT' Path='H-Drive\Bat_Cis\RUN' Size='     1,280' Date='2008-06-02   18:01' />
<FileLine Name='SUUP08R.PCO' Path='L-Drive\COB_2000\COMPILE\SOURCE' Size='    83,454' Date='2008-06-02   18:19' />
<FileLine Name='SUUP08R.EXE' Path='H-Drive\Bat_Cis\RUN\BIN\' Size='          ' Date='0001-01-01   00:00' />
<FileLine Name='SUPADJ.BAT' Path='H-Drive\Bat_Cis\RUN' Size='     1,277' Date='2008-06-02   18:01' />
<FileLine Name='SUUP04R.PCO' Path='L-Drive\COB_2000\COMPILE\SOURCE' Size='    37,339' Date='2008-06-02   18:19' />
<FileLine Name='SUUP04R.EXE' Path='H-Drive\Bat_Cis\RUN\BIN\' Size='          ' Date='0001-01-01   00:00' />
<FileLine Name='REFRESH.ADHOC.bat' Path='H-Drive\Bat_Cis\RUN' Size='     2,061' Date='2008-06-02   18:01' />
<FileLine Name='GEC_SNAPSHOT_REFRESH.SQL' Path='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL' Size='     7,176' Date='2008-06-02   18:01' />
<FileLine Name='TEMP_CLAIM_REFRESH.SQL' Path='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL' Size='     1,055' Date='2008-06-02   18:01' />
<FileLine Name='GCTRPL.bat' Path='H-Drive\Bat_Cis\RUN' Size='     1,383' Date='2008-06-02   18:01' />
<FileLine Name='GCTRPL.SQL' Path='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL' Size='     7,075' Date='2008-06-02   18:01' />
<FileLine Name='WRR_CANCEL_NOTIFICATION_SQL.bat' Path='H-Drive\Bat_Cis\RUN' Size='       869' Date='2008-06-02   18:01' />
<FileLine Name='EXECUTE_WRR_CANCEL_NOTIFICATION.SQL' Path='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL' Size='       225' Date='2008-06-02   18:01' />
<FileLine Name='CleanUp_Processes.bat' Path='H-Drive\Bat_Cis\RUN' Size='     1,212' Date='2008-06-02   18:01' />
<FileLine Name='CLEANUP_ORPHANED_PROCESSES.SQL' Path='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL' Size='       401' Date='2008-06-02   18:01' />
<FileLine Name='REFRESH.VICTOR.bat' Path='H-Drive\Bat_Cis\RUN' Size='     1,302' Date='2008-06-02   18:01' />
<FileLine Name='VICTOR_SNAPSHOT_REFRESH.SQL' Path='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL' Size='     7,159' Date='2008-06-02   18:01' />
<FileLine Name='CLEARVARS.BAT' Path='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\INCLUDE' Size='       210' Date='2008-06-02   18:14' />
</FilesList>
<ShapeNodes>
<ShapeLine ShapeID='21' Text='REFRESH.VICTOR
.BAT' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' ValuePath='Terminator,1/Process,21'  />
<ShapeLine ShapeID='18' Text='CleanUp_Processes
.BAT' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' ValuePath='Terminator,1/Process,18'  />
<ShapeLine ShapeID='15' Text='WRR_CANCEL_NOTIFICATION_SQL
.BAT' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' ValuePath='Terminator,1/Process,15'  />
<ShapeLine ShapeID='12' Text='GCTRPL
.BAT' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' ValuePath='Terminator,1/Process,12'  />
<ShapeLine ShapeID='9' Text='REFRESH.ADHOC
.BAT' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' ValuePath='Terminator,1/Process,9'  />
<ShapeLine ShapeID='6' Text='SUNITED
.BAT' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' ValuePath='Terminator,1/Process,6'  />
<ShapeLine ShapeID='26' Text='End' ImageToolTip='' ValuePath='Terminator,1/Terminator,26'  />
<ShapeLine ShapeID='4' Text='INITGLOBALS
.BAT' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' ValuePath='Terminator,1/Process,4'  />
<ShapeLine ShapeID='24' Text='CLEARVARS
.BAT' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' ValuePath='Terminator,1/Process,24'  />
<ShapeLine ShapeID='1' Text='daily.bat' ImageToolTip='' ValuePath='Terminator,1'  />
</ShapeNodes>
<TreeView>
<TreeNode ShapeId='1' ParentShapeID='0' Text='daily.bat' Value='Terminator,1' ImageToolTip='' Tooltip='0%2c%0d%0a0%2c%2fDAILY.CMD%0d%0a1%2cECHO+EXIT+WILL+PREVENT+JOB+FROM+RUNNING+AS+NON-REXX+CMD+FILE+AND%0d%0a0%2cECHO+LOOPING+THE+SUBMIT+BELOW%0d%0a0%2cEXIT%0d%0a1%2cPOWERJOB+%2fPROC%3adaily_yyyymmdd.CMD+%2fPARM%3aSTEPA1+%2fPRI%3a5+%2fLOG%3aSU+%2fSRV%3aGRACE%0d%0a1%2cThis+job+performs+regularly+recurring+daily+tasks+run+in+batch+mode.%0d%0a1%2cNormally+SUNITED+and+SNAPSHOTS+are+always+run.++Other+jobs+can+be%0d%0a1%2cadded+following+these+if+needed.%0d%0a1%2cSearch+for++ADD+STEP++to+find+the+section+where+jobs+may+be+added.%0d%0a1%2cEach+day+create+a+DAILY_yyyymmdd.cmd+file+for+the+nitely+run.%0d%0a1%2cMAKE+SURE+the+cmd+file+name+in+the+POWERJOB+line+is+correct%3a%0d%0a0%2ci.e.%3a+++DAILY_yyyymmdd+(update+yymmdd+to+correct+date+and%0d%0a0%2csave+file+to+that+file+name).%0d%0a0%2c!!+NOTE%3a++Until+we+make+this+slicker+be+sure+to+change+all+3+occurrances%0d%0a0%2c(8+Mar+96)++of+DAILY.CMD+to+DAILY_yyyymmdd.CMD+before+running%0d%0a1%2ctoday's+job.%0d%0a1%2c!!+NOTE%3a++If+adding+a+compare+and+update(DX+job)+change%0d%0a1%2cthe+snapshot+jobs+to%3a%0d%0a0%2ccont_gecmdsnap.cmd%2fREFRESH.ADHOC.NOMD.CMD+%3c-+ADHOC%0d%0a0%2cdlg+++++++25+Feb+2008+++++++Change+Q%3a%5c+to+H%3a%5c+for+Client3+implementation.%0d%0a0%2cYSH%0926+Jun+2006%09++Added+call+to+restart+instance%2c+keep+this+line+always+commented%0d%0a0%2cDLG+++++++23+Apr+2004+++++++remove+adhoc+refresh%0d%0a0%2cJHB+++++++17+Feb+2004+++++++PGMCHG2004-004%3a%0d%0a1%2cSet+directory+path+for+reports+for+this+job%3a%0d%0a1%2cJHB+++++++++++++++++++++++++1.++Save+initial+BatReport+setting+for+restore+at+CLEANUP%0d%0a1%2cJHB+++++++++++++++++++++++++2.++Set+report+path+for+job%0d%0a0%2cYSH%0910%2f21%2f03%09++Added+call+to+refresh+snapshots+at+VICTOR%0d%0a0%2cYSH+%0906%2f23%2f2003+%09++Added+call+to+delete+Orphaned+processes%0d%0a0%2cDan+Gandy++++++21+Apr+2003++Comment+out+NITESUB.+no+longer+needed.%0d%0a0%2cDan+Gandy+++++++3+Oct+2002++Changed+waittime+to+03%3a00%3a00+from+21%3a30%3a00%0d%0a0%2cper+j.+Hiatt%0d%0a0%2cDan+Gandy+++++++3+Apr+2000++Remove+OverNight_aps_ddl_move.cmd%0d%0a0%2cGandy++++++++++21+Mar+2000++Added+sqlplus+compiled+procdure+for+WinRiskRE+to+setup%0d%0a1%2cthe+120+day+Cancelation+Notification+process%0d%0a1%2cMark+Deitrick++07+JUN+1999++Added+SQL+to+create+groups+daily+tables+and+views.%0d%0a0%2cGandy++++++++++15+Apr+1999++COMMENT+OUT+AC_RECONCILE.CMD+FOR+rad+cession%0d%0a0%2ccutover.%0d%0a0%2cDan+Gandy++++++11+dec+1998++remove+expalcie.+no+longer+exists.%0d%0a0%2cDan+Gandy++++++14+Oct+1998++Add+del+for+%5c%5catls000107%5cpdisksnapshot.flg+(adhoc+refresh+waitfile)%0d%0a0%2cAdd+WaitFile+before+additional+steps.%0d%0a0%2cMark+Deitrick++31+Oct+1997++Added+ANALYZE+of+ALCIE2+objects+to+Tuesday's+run.%0d%0a0%2cDan+Gandy++++++21+Aug+1997++Add+check+for+day+of+week%2c+on+Tuesday%0d%0a0%2cexecute+one+set+of+ANALYZE_...cmd%2c+and%0d%0a0%2con+Wednesday+execute+another.%0d%0a0%2cDan+Gandy++++++27+Jun+1997++Replace+UPDATE.NEWGEC.FROMADA2.CMD+which%0d%0a0%2c%22refreshes+APS+executables%22+with%0d%0a0%2cOVERNIGHT_APS_DLL_MOVE.CMD+per+JAB.%0d%0a1%2cDan+Gandy++++++17+Apr+1997++add+Fallout+reports+for+Grace%2c+Adhoc+and%0d%0a0%2cChris+(per+Deitrick's+request).%0d%0a0%2cDan+Gandy++++++03+Dec+1996++Move+Nitesub+to+just+after+SUNITED%0d%0a0%2cLuke+Balding+++12+May+1996++Added+ExpVal%0d%0a0%2cLuke+Balding+++12+Apr+1996++Added+SubmitClosed%0d%0a0%2cLuke+Balding+++06+Apr+1996++Added+Alcie+Export(expalcie.cmd)%0d%0a0%2cJanet+Baughman+08+Mar+1996++Move+CALL+WAITTIME+to+STEPA1%0d%0a0%2cJanet+Baughman+07+Mar+1996++Added+r%3a%5cCMD%5cAC_Reconcile.CMD+to+DAILY%0d%0a0%2cand+queueing+process+to+cause+it+and+associated%0d%0a0%2cAC_Reconcile_run.CMD+to+run+first%2c%0d%0a0%2csingle+threaded.%0d%0a1%2cAdded+RunThenPauseIfError+routine+to+handle%0d%0a0%2cselect+statement+processing.%0d%0a0%2cLuke+Balding+++15+Feb+1996++Removed+Edgar's+snapshots%0d%0a0%2cLuke+Balding+++06+Feb+1996++added+UTIL+routine+(moving+procedures+that+were+on%0d%0a0%2cEDGAR+DBSCHED+to+here+were+applicable).%0d%0a0%2cLuke+Balding+++26+Jan+1996++change+cont_edgarsnap.cmd+edgar_mdrefresh.cmd%0d%0a1%2cJanet+Baughman+01+Jan+1996++Created+Job%0d%0a0%2cFran+Brisendine+30+June+1999+Chg'd+Waittime+to+21%3a30%3a00+to+accomodate+anyone+desiring+to+work%0d%0a0%2cpast+17%3a30%3a00...%0d%0a0%2c%0d%0a1%2c22+May+2008+-+MLDIL+-+per+Melvina+Edwards+(DBA)+do+not+use+the+CleanUp_Orphaned_Processes%0d%0a0%2cparagraph+anymore%0d%0a1%2c17+Feb+2004+-+MLJHB%0d%0a0%2cPGMCHG2004-004%3a%0d%0a1%2cReset+batReport+Environment+Variable+in+case+a+restart+is%0d%0a0%2cdone+in+same+window...to+make+sure+you+start+out+with%0d%0a0%2cthe+correct+base+directory.++(Updated+29+Apr+04-MLJHB)%0d%0a1%2cSet+directory+path+for+reports+for+this+job%3a%0d%0a1%2c1.++Save+initial+BatReport+setting+for+restore+at+CLEANUP%0d%0a1%2c2.++Set+report+path+for+job%0d%0a1%2cSET+batReport%3dq%3a%5cbat_cis%5crun%5creports%5c%0d%0a0%2ccall+%3aREFRESH_ADHOC%0d%0a0%2ccall+%3aREFRESH_SA_ESTIMATES%0d%0a0%2ccall+%3aCleanUp_Orphaned_Processes%0d%0a0%2c%0d%0a0%2c%0d%0a0%2c-----+REFRESH+ADHOC+------+%2f%0d%0a0%2c---------Group's+Daily+Tables%2fViews---------------------------------%2f%0d%0a1%2c------+WinRiskRe+Cancel+Notification+-----+%2f%0d%0a0%2c------+CleanUp+Orphaned+Processes+-----+%2f%0d%0a0%2c%0d%0a0%2c-----+REFRESH+VICTOR+------+%2f%0d%0a0%2cREFRESH+TABLES+IN+THE+RAD+SA+ESTIMATES+SYSTEM%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cLOGMSG+1+%22BEGIN++REFRESH+SA+ESTIMATES+%22%0d%0a0%2c%0d%0a0%2ccall+REFRESH.SAEstimates.bat%0d%0a0%2c%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cLOGMSG+1+%22END++REFRESH+SA+ESTIMATES+%22+%25ERRORLEVEL%25%0d%0a0%2c%0d%0a0%2cgoto+%3aeof%0d%0a0%2cRestart+Instance%0d%0a0%2cYSH+06%2f26%2f2003+to+restart+instance+only+today%0d%0a0%2c------Restart+Instance+-----------------%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cLOGMSG+1+%22BEGIN++RESTART+INSTANCE%22%0d%0a0%2ccall+Restart_Instance.bat%0d%0a1%2cIF+NOT+%25ERRORLEVEL%25+EQU+0+(%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cLOGMSG+1+%22END+ERROR+RESTART+INSTANCE%22+%25ERRORLEVEL%25%0d%0a0%2c)+else+(%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cLOGMSG+1+%22END+SUCCESS+RESTART+INSTANCE%22+%25ERRORLEVEL%25%0d%0a0%2c)%0d%0a0%2c%0d%0a0%2cgoto+%3aeof%0d%0a' Checked='False' Expanded='True' Target='' Selected='False' />
<TreeNode ShapeId='2' ParentShapeID='1' Text='INITGLOBALS
.BAT' Value='Process,4' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' Tooltip='0%2c%0d%0a0%2cintiGlobals.bat%0d%0a0%2csets+globals+for+batch+runs%0d%0a0%2cusage%3a%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cINITGLOBALS.BAT+%22PROG%3dMONTHEND_ACCESS%22%0d%0a0%2c%0d%0a' Checked='False' Expanded='True' Target='' Selected='False' />
<TreeNode ShapeId='3' ParentShapeID='1' Text='SUNITED
.BAT' Value='Process,6' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' Tooltip='0%2cSUNITED+%2f%0d%0a0%2c%0d%0a0%2cexit%0d%0a0%2c%0d%0a1%2cPOWERJOB+%2fPROC%3asunited.CMD+%2fPRI%3a5+%2fLOG%3aSU+%2fSRV%3aGRACE%0d%0a0%2c%0d%0a0%2cJD%0d%0a1%2cJD++THIS+JOB+PERFORMS+NIGHTLY+MAINTENANCE+TO+THE+RISK%0d%0a0%2cJD++SUMMARY+TABLES.+MONTHLY+VERSION%2c+DOES+NOT+INCLUDE+CLAIMS%0d%0a0%2cJD++BRIDGE+OR+TREATY+PLAN+PROCESSING+UPDATES%0d%0a0%2cJD%0d%0a0%2cJD++NIGHTLY+MAINTENANCE+INCLUDES%3a%0d%0a0%2cJD+++++UPDATE+OF+THE+TREATY%2fPLAN+PROCESSING+TABLE%0d%0a0%2cJD+++++UPDATE+PREMIUM+TABLE+SUMMARIZING+CLAIMS+DATA+BY+PLAN%0d%0a0%2cJD+++++ADJUSTMENT+OF+YTD+INFORCE+NUMBERS+IN+DETAIL+ROWS%0d%0a0%2cJD+++++CREATION+OF+YTD+INFORCE+AND+PREMIUM+ROWS%0d%0a0%2cJD%0d%0a0%2cJD++IT+EXECUTES+THE+FOLLOWING+PROCS%3a%0d%0a1%2cJD+++++SUTRPL+-+UPDATE+TREATY+PLAN+PEOCESSING+TABLE%0d%0a1%2cJD+++++SUIADJ+-+ADJUST+YTD+INFORCE+NUMBERS+IN+INFORCE+TABLE%0d%0a1%2cJD+++++SUIYTD+-+TOTAL+YTD+INFORCE+ESTIMATE%2fCREATE+'T'+RECS%0d%0a1%2cJD+++++SUPADJ+-+ADJUST+YTD+PREMIUM+NUMBERS+IN+PREMIUM+TABLE%0d%0a0%2cJD%0d%0a1%2cJH++JOB+HISTORY%0d%0a0%2cJH++++DATE++++++BY+++++++PROJ++++++++++DESC%0d%0a0%2c%0d%0a1%2c18+Feb+2004+JHB++PGMCHG2004-004++Change+report+file+names%0d%0a0%2c10+Dec+1995++Luke+Balding++Maint+Added+%2fTEST+switch+to+snapshot%0d%0a0%2csubmit.%0d%0a0%2c14+Nov+1995++Luke+Balding++++++++Added+submission+of+Snapshots%0d%0a1%2c03.31.95++mljb+++++++++++++++++++Create++++++++++++++++++++%2f%0d%0a0%2c%0d%0a1%2ccall+joblib++SetJobLib()%0d%0a0%2c%0d%0a1%2cIF+%25ERRORLEVEL%25+NEQ+0+(%0d%0a0%2cset+errStep%3dSUTRPL1%0d%0a0%2cgoto+%3acleanUp%0d%0a0%2c)%0d%0a1%2cIF+%25ERRORLEVEL%25+NEQ+0+(%0d%0a0%2cset+errStep%3dSUIADJ%0d%0a0%2cgoto+%3acleanUp%0d%0a0%2c)%0d%0a1%2cIF+%25ERRORLEVEL%25+NEQ+0+(%0d%0a0%2cset+errStep%3dSUIYTD%0d%0a0%2cgoto+%3acleanUp%0d%0a0%2c)%0d%0a1%2cIF+%25ERRORLEVEL%25+NEQ+0+(%0d%0a0%2cset+errStep%3dSUPADJ%0d%0a0%2cgoto+%3acleanUp%0d%0a0%2c)%0d%0a0%2cBegin+SUTRPL1%0d%0a1%2c---------+UPDATE+ROWS+THAT+REPORTS+MIGHT+USE+----------%0d%0a1%2cSUTRPL+-+Update+the+Treaty-Plan+Processing+Table+-+SUUP11R%0d%0a0%2cEnd+SUTRPL1%0d%0a0%2cBegin+SUIADJ%0d%0a1%2cSUIADJ+-+Adjust+Inforce++++++++++++++++++++++++++-+SUUP03R%0d%0a1%2cPRINTED+EARLY%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cSETOUTFILE.BAT+SU.P.INFADJ.RPT%0d%0a0%2cEnd+SUIADJ%0d%0a0%2cBegin+SUIYTD%0d%0a1%2cSUIYTD+-+Compute+YTD+Inforce+Rows++++++++++++++++-+SUUP08R%0d%0a1%2cNOT+PRINTED%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cSETOUTFILE.BAT+SU.P.INFYTD.RPT%0d%0a0%2cEnd+SUIYTD%0d%0a0%2cBegin+SUPADJ%0d%0a1%2cSUPADJ+-+Compute+YTD+Premium+Rows++++++++++++++++-+SUUP04R%0d%0a1%2cNOT+PRINTED%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cSETOUTFILE.BAT+SU.P.PRMADJ.RPT%0d%0a0%2cEnd+SUPADJ%0d%0a' Checked='False' Expanded='False' Target='_top' Selected='False' />
<TreeNode ShapeId='4' ParentShapeID='3' Text='SUTRPL
.BAT' Value='Process' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\SUNITED.bat' Tooltip='0%2c%0d%0a1%2cSUTRPL+-+Update+Treaty%2fPlan+Processing+Table%0d%0a0%2c%0d%0a1%2c(Run+from+JOB+SULGRFM.CMD)%0d%0a1%2cMLJB+-+02%2f27%2f95%0d%0a0%2c%0d%0a0%2c%40echo+off%0d%0a1%2cif+cntlcard+not+passed+then+set+to+default%0d%0a0%2cneeded+to+enable+output+redirection+and+block+'application+terminated'+popup+window%0d%0a' Checked='False' Expanded='False' Target='0' Selected='False' />
<TreeNode ShapeId='8' ParentShapeID='4' Text='emptycrd
.CRD' Value='Card' ImageToolTip='c:\users\dad\documents\h-drive\bat_cis\run\crd\emptycrd.crd' Tooltip='' Checked='True' Expanded='False' Target='' Selected='False' />
<TreeNode ShapeId='5' ParentShapeID='8' Text='SUUP11R
.EXE' Value='Predefined process' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP11R.PCO' Tooltip='0%2cAUTHOR.+++++T.+K.+Penn-David%0d%0a0%2cREMARKS.%0d%0a1%2cThis+Program+and+all+associated+documentation+are+the%0d%0a0%2cexclusive+property+of+Munich+American+Reassurance+Company%0d%0a0%2cPD++++++%3d%3d%3e+Program+Description%0d%0a1%2cProgram+to+Create+Monthly+Treaty%2fPlan+Processing+Table%0d%0a0%2cFD++++++%3d%3d%3e+Files+Description%0d%0a0%2cDB2+Tables+in%0d%0a0%2cClient+Company%0d%0a0%2cSummary+Control%0d%0a0%2cPlan+General%0d%0a0%2cTreaty+General%0d%0a0%2cTreaty%2fPlan+Characteristics%0d%0a1%2cTreaty%2fPlan+Reporting%0d%0a0%2cTreaty%2fPlan+Reference%0d%0a0%2cTreaty%2fPlan+Billing%0d%0a0%2cDB2+Table+Out%0d%0a0%2cTreaty%2fPlan+Processing%0d%0a0%2cCD+++++++%3d%3d%3e+Communications+Description%0d%0a0%2cPN+++++++%3d%3d%3e+Program+Narrative%0d%0a0%2cIII.+PROGRAM+NARRATIVE%3a%0d%0a1%2c1.+Read+control+card%2c+if+present%2c+to+determine+chosen+activity%0d%0a1%2cdate.++If+not+present%2c+read+SU+DATE+CONTROL+table.%0d%0a0%2c2.+Delete+all+existing+entries+in+the+table+for+the+chosen%0d%0a0%2cActivity+month.%0d%0a0%2c3.+Open+cursor+that+includes+all+treaty%2fplan+references%0d%0a0%2c4.+Read+cursor.++For+each+Treaty+or+Plan+in+the+cursor%2c+look%0d%0a0%2cup+a+relevant+Treaty+%26+Plan+parts+and+INSERT+a+row+in+the%0d%0a0%2cTreaty%2fPlan+processing+table.%0d%0a0%2cPH+++++++%3d%3d%3e+Program+History%0d%0a0%2cIV.+PROGRAM+HISTORY%3a%0d%0a0%2cDATE++++++++BY++++PROJ%23+DESCRIPTION%0d%0a0%2c05+JUL+2007++MLDIL+Maint+PRGCHG2007-022%3a%0d%0a0%2c1.+Added+ZERO_FY_PREM_FLAG+from+the%0d%0a0%2cTREATY_ORD+table+to+Trty_Plan_Proc.%0d%0a0%2c2.+Added+column+to+copybook+RRTB700.%0d%0a0%2c3.+Commented+out+the+reference+to%0d%0a0%2c'Use+Rollback+Segment+RS_99'.%0d%0a0%2c17+Nov+2005++MLDIL+Maint+PRGCHG2005-135%3a%0d%0a0%2cCloned_Treaty_Flag+and+Orig_Treaty%0d%0a0%2c_ID+added+to+Trty_Plan_Proc.++Added%0d%0a0%2cto+copybook+RRTB700+also.%0d%0a0%2c14+Sep+2004++MLDG++Maint+PRGCHG2004-047%3a%0d%0a0%2cPrimary_company+added+to+TRTY_PLAN_%0d%0a0%2cProc.++Copybook+RRTB700+(Trty_Plan_%0d%0a0%2cProc)+also+updated.%0d%0a0%2c25+May+2004++MLJHB+Maint+PRGCHG2004-021%3a%0d%0a0%2cXXX_IND+added+to+Treaty_Char+and%0d%0a0%2cTRTY_Plan_Proc.++Must+be+selected%0d%0a0%2cfrom+Treaty_Char+and+updated+in%0d%0a0%2cTRTY_Plan_Proc.++RRTB700%0d%0a0%2c(Trty_Plan_Proc)+and+RRTB010%0d%0a0%2c(Treaty_Char)+copybooks+also%0d%0a0%2cupdated+with+XXX_IND+and+XXX-IND.%0d%0a0%2c02+Mar+2004++MLJHB+Maint+PRGCHG2004-004%3a%0d%0a0%2c2900-Find-Bridge-Data%3a%0d%0a0%2cSet+Novate-Date+of+RRTB700-REC+%3d%0d%0a0%2cspaces+prior+to+SELECT.%0d%0a0%2c01+Mar+2004++MLJHB+Maint+PRGCHG2004-005%3a%0d%0a0%2c2900-Find-Bridge-Data%3a%0d%0a0%2cChange+Novate+date+default+to+NULL%0d%0a0%2c29+Oct+2003++MLJHB+Maint+2900-Find-Bridge-Data%3a%0d%0a0%2cChange+Select+to+Select+DISTINCT%0d%0a0%2cto+allow+for+multiple+treaty_id%0d%0a0%2crows.++Unique+level+now+must%0d%0a0%2cinclude+plan_id.%0d%0a0%2c07+Oct+2003++MLJHB+Maint+3000-Find-Auto-Retro-Percent%3a%0d%0a0%2cSet+Null+Ind+before+Select%0d%0a0%2cso+'not+found'+condition%0d%0a0%2cproduces+a+NULL+in%0d%0a0%2c4000-INSERT-TRTY-PLAN.%0d%0a0%2c23+Jul+2002++dil+++Maint+1.+See+2900-Find-Bridge-Data%2c%0d%0a0%2clook+for+CNA+Plans+at+the+Treaty%0d%0a0%2clevel.++When+multiple+Plans+exist%2c%0d%0a0%2conly+one+was+getting+updated+with%0d%0a0%2cthe+CNA+info.%0d%0a0%2c2.+Auto_Retro_Percent+field+was%0d%0a0%2cadded+to+the+Trty_Plan_Proc+table%3a%0d%0a0%2ca.+Add+RRTB522+to+SQL+Includes%0d%0a0%2cb.+Add+Auto+Retro+Percent+table%0d%0a0%2clookup%0d%0a0%2cc.+Add+field+to+the+Insert+SQL%0d%0a0%2c28+Feb+2002++DLG+++Maint+Add+Primary_Treaty_ID%0d%0a0%2c02+Feb+2001++MLJB++Maint+Incorporate+new+columns+into%0d%0a0%2cTrty_Plan_Proc+to+allow+users%0d%0a1%2cto+identify+business+acquired%0d%0a0%2cthru+purchase+of+another%0d%0a0%2ccompany.++Originally+being+set%0d%0a1%2cup+to+identify+business+from+the%0d%0a0%2c1%2f1%2f2001+CNA+deal.++New+table%0d%0a0%2cused+to+do+the+tracking+is%0d%0a0%2cRRTB070+(Integration_Bridge).%0d%0a0%2cNew+code+is+in%0d%0a0%2c2900-FIND-BRIDGE-DATA%2c+with%0d%0a0%2cadditional+columns+added+to+TPP%0d%0a0%2cin+4000-INSERT-TRTY-PLAN.%0d%0a0%2c08+Mar+2000++dil+++Maint+Added+NAIC-Code+and+Comp-Fed-ID%0d%0a0%2cto+SQL+Select+clause+from+the%0d%0a1%2cClient_Company+table+-+see+2400-%0d%0a0%2cRead-Comp-Prof+para.%0d%0a0%2c06+SEP+1999++dlg+++Maint+Initialize+Benefit_Type+in+2700-%0d%0a0%2cto+prevent+insertion+of+data+from%0d%0a0%2cprevious+lookup.%0d%0a0%2c02+Sep+1999++dlg+++Maint+Add+Benefit_type+to+table%2c+pull%0d%0a0%2cfrom+Summary+Control.%0d%0a0%2c28+Aug+1998++ck++++Maint+7000-add+display+to+disregard%0d%0a0%2cT%2fP+errs+plans+3690-4152+due+to%0d%0a0%2cinvalid+treaty+%3d+0+on+pl+gen.%0d%0a0%2c08+Jul+1998++dlg+++maint+Add+set+rollback+segment+99.%0d%0a0%2c21+May+1998++dlg+++maint+9000-+shorten+displays.%0d%0a0%2c16+Apr+1998++ck++++maint+9000-+shorten+displays.%0d%0a0%2c30+Mar+1998++ck++++maint+1000-Mainline%3a+comment+displays.%0d%0a0%2c09+Oct+1997++JB++++Maint+Changes+for+Y2000+compliance%3a%0d%0a0%2c%3d%3d%3e+WS-CNTL-CARD%0d%0a0%2c%3d%3d%3e+DB2-Activity-Date-CCYY%0d%0a0%2c%3d%3d%3e+7110-Edit-Control-Card%0d%0a0%2c09+Dec+1995++mllb++++++++Added+select+of+Program+Title.%0d%0a1%2c26+Aug+1995++mllb++++++++CNV+-+Added%2c+use+batch+rollback.%0d%0a0%2c01+Jun+1994++tkpd++maint+Correct+RETURN+CODE+on+errors.%0d%0a0%2c29+Jun+1993++tkpd++maint+Limit+date+range+on+Rptg+part.%0d%0a0%2c18+Jun+1993++tkpd++maint+Add+Old+Account+Number.%0d%0a0%2c19+Apr+1993++tkpd++maint+Improve+error+messages.%0d%0a0%2c07+Apr+1993++tkpd++maint+Fix+bug+causing+Plan+ID+to+be%0d%0a0%2cassigned+to+wrong+Company.%0d%0a1%2c07+Jan+1993++tkpd++maint+Modify+to+limit+date+range.%0d%0a1%2c25+Aug+1992++CK++++AC++++Add+field+-+Primary+Plan+ID.%0d%0a1%2c01+Jul+1992++CK++++AC++++Add+field+-+SU+Control+ID.%0d%0a0%2c26+JUN+1992++CK++++AC++++Add+Plan+Name+and+Bill+fields.%0d%0a0%2c24+JUN+1992++CK++++AC++++Use+RRTB040+(Treaty%2fPlan+Ref)%0d%0a0%2cinstead+of+SU+Summary+Control.%0d%0a0%2c27+Dec+1991++TKP-D+SU++++Add+Fields.%0d%0a1%2c18+Jul+1991++TKP-D+SU++++Create.%0d%0a0%2c10+Apr+2008+MHR+GEC+Replatform+Added+%2b1403+where+sqlcode+%3d+100%0d%0a1%2c09+Oct+97+-+Baughman+-+Changes+for+Y2000+compliance.%0d%0a0%2c05++FILLER++++++++++++++++++++++++++++++++++++++++PIC+X(03).%0d%0a1%2c09+Oct+97+-+Baughman+-+Changes+for+Y2000+compliance.%0d%0a0%2c10++DB2-Activity-Date-CC++++++++++++++++++PIC+X(02).%0d%0a0%2c10++DB2-Activity-Date-YY++++++++++++++++++PIC+X(02).%0d%0a1%2c25+May+2004+-+PGMCHG2004-021+-+MLJHB%0d%0a1%2c23+Jul+2002+by+D.+Linke+-+added+indicator+for+processing+nulls%0d%0a1%2c14+Aug+2004+by+D.+Gandy+-+added+indicator+for+processing+nulls%0d%0a1%2c17+Nov+2005+by+D.Linke+-+added+indicator+for+processing+nulls%0d%0a1%2c05+Jul+2007+by+D.Linke+-+added+indicator+for+processing+nulls%0d%0a0%2cCopybook+for+call+to+old+Account+Number+routine%0d%0a0%2c----------------------------------------------------------------%0d%0a0%2cSQL+INCLUDES%0d%0a0%2c----------------------------------------------------------------%0d%0a0%2cClient+Company%0d%0a0%2cIntegration_Bridge%0d%0a1%2c02+Feb+2001+-+MLJB%0d%0a0%2cTreaty+General%0d%0a0%2cTreaty%2fPlan+Characteristics%0d%0a0%2cTreaty+Ord%0d%0a0%2cadd+Treaty_ORD+table+to+get+Zero_FY_Pren_Flag%0d%0a1%2cprgchg2007-022+-+dil+05+jul+2007%0d%0a0%2cTreaty%2fPlan+Billing%0d%0a1%2cTreaty%2fPlan+Reporting%0d%0a0%2cPlan+General%0d%0a0%2cTreaty+Class+(AS+LOB)%0d%0a0%2cAuto+Retro+Percent+Table%0d%0a0%2cTreaty%2fPlan+Processing+Table%0d%0a0%2cDate+Record%0d%0a0%2cSummary+Control%0d%0a0%2cTreaty%2fPlan+Reference+Table%0d%0a0%2cSQL+Cursors%0d%0a0%2cSelect+all+Treaties+%26+Plans+from+the+Treaty+Plan+Reference%0d%0a0%2cTable%0d%0a0%2c0000-MAINLINE.%0d%0a1%2c16+Aug+2007++D.Linke+-+Commented+out+'Set+Rollback%0d%0a0%2cSegment+99'+because+it+is+no%0d%0a0%2clonger+needed+and+is+NOT+available%0d%0a0%2con+the+GraceDev+server.%0d%0a1%2c08+Jul+1998++dlg+-+add+set+rollback+segment+99%0d%0a0%2cEXEC+SQL%0d%0a0%2cSET+TRANSACTION+USE+ROLLBACK+SEGMENT+RS_99%0d%0a0%2cEND-EXEC.%0d%0a0%2cOpen+Treaty%2fPlan+Reference+Cursor%0d%0a0%2cRead+and+Process+Each+Control+Row%3a%0d%0a0%2cWhen+Entry+Level+Changes%2c+write+out+Data+Extract%0d%0a0%2cDISPLAY+'Processing+Treaty%2fPlan'%2c%0d%0a0%2c'++Treaty+Plan+Code+'%2c%0d%0a0%2cTreaty-Plan-Code+OF++RRTB040-REC%0d%0a0%2c'++Reference+ID+'%2c%0d%0a0%2cReference-ID++OF++RRTB040-REC%0d%0a0%2cELSE%0d%0a0%2cDISPLAY+'+++-----------------------------------+'%0d%0a0%2cDISPLAY+'+++!!!!!+E+R+R+O+R+!!!!!++++'%0d%0a0%2cDISPLAY+'+++Either+Plan+General%2c+Treaty+General+'%0d%0a0%2cDISPLAY+'+++Treaty%2fPlan+Char+or+Company+Profile+'%0d%0a0%2cDISPLAY+'+++was+not+successfully+read...++++++++'%0d%0a0%2cDISPLAY+'+++-----------------------------------+'%0d%0a0%2cFetch+next+row+of+the+cursor%0d%0a0%2cadd+display+for+temp+problem+to+find+where+we+get+stuck%0d%0a1%2c-+dlg+17+Jan+97%0d%0a1%2c-+jhb+20+Jan+97+-+commented+out+display%0d%0a0%2cdisplay+'ref+'+reference-id+of+rrtb040-rec%0d%0a0%2c'+'+treaty-plan-code+of+rrtb040-rec%0d%0a0%2cRe-initialize+fields+%26+set+up+record+keys%0d%0a0%2cFind+Characteristics%0d%0a0%2cFind+Treaty+General+(region+%26+company+ID%0d%0a0%2cFind+Company+Name%0d%0a0%2cFind+Treaty+or+Plan+Billing%0d%0a1%2cFind+Treaty+or+Plan+Reporting%0d%0a0%2cFind+Summary+Control%0d%0a0%2cFind+Old+Account+Number%0d%0a0%2c23+Jul+2002++dil++++Change+2900-Find-Bridge-Data%2c%0d%0a0%2clook+for+CNA+Plans+at+the+Treaty%0d%0a0%2clevel.%0d%0a1%2c02+Feb+2001+-+MLJB++Perform+routine+to+lookup+data%0d%0a1%2cfrom+Integration_Bridge+if+this%0d%0a0%2cis+a+Plan+level+row.%0d%0a1%2c23+Jul+2002+by+MLDIL+-+Perform+routine+to+lookup+data+from%0d%0a0%2cAuto_Retro_Percent+table.%0d%0a1%2c05+Jul+2007+by+DIL+-+prgchg2006-022%3a+Perform+routine+to%0d%0a0%2clookup+data+of+zero_fy_prem_flag%0d%0a0%2cfrom+treaty_ord%0d%0a0%2cFind+Treaty+ID+for+a+Plan%0d%0a1%2c17+Nov+2005+-+PRGCHG2005-135+-+MLDIL%3a+Add+Cloned_Treaty_Flag%0d%0a0%2cand+Orig_Treaty_ID+to+select%0d%0a1%2c25+May+2004+-+PRGCHG2004-021+-+MLJHB%3a+Add+XXX_IND+to+select%0d%0a0%2cDepending+on+the+AS_LOB%2c+either+REGION+or+SUBREGION+is%0d%0a1%2cused+for+Reporting+purposes%0d%0a1%2c09+Mar+2000+by+Debra+Linke+-+add+the+NAIC-Code+and+the%0d%0a0%2cComp-Fed-ID+to+the+Select+statement+of+the+Client_Company%0d%0a0%2ctable.++Per+Dan+Gandy.%0d%0a1%2c14+Aug+2004+by+D.+Gandye+-+add+Primary-Company+to+the+Select%0d%0a0%2cstatement+of+the+Client_Company+table.++PRGCHG2004-047%0d%0a0%2cRead+Treaty+or+Plan+Billing%0d%0a0%2cNo+Treaty+Part+%3a+Set+indicator+variables+to+NULL%0d%0a0%2cCheck+for+Treaty+Default+for+this+plan%0d%0a0%2cDISPLAY+'++NO+BILLING+PROFILE'%0d%0a1%2cFind+Treaty+or+Plan+Reporting%0d%0a0%2cNo+Treaty+Part+%3a+Set+indicator+variables+to+NULL%0d%0a0%2cCheck+for+Treaty+Default+for+this+plan%0d%0a0%2cFind+Treaty+or+Plan+Summary+Control+ID%0d%0a1%2cIf+no+match%2c+set+indicator+to+nulls%0d%0a1%2cadd+benefit_type+to+tpp+table+-+dlg+02+Sep+99%0d%0a1%2cinitialize+benefit_type+-+dlg+07%0d%0a1%2c02+Feb+2001+-+MLJB++Routine+to+lookup+data+from+the%0d%0a0%2cIntegration_Bridge.%0d%0a0%2cInitialize+for+Integration_Bridge+data.%0d%0a1%2c01+Mar+2004+MLJHB+-+PGMCHG2004-005+-+Novate+date+default+is+NULL%0d%0a0%2cMove+-1+to+Novate-Date-IND.%0d%0a1%2c29+Oct+2003+MLJHB+-+Change+SELECT+to+SELECT+DISTINCT+to%0d%0a0%2callow+for+multiple+plans+under+1%0d%0a0%2ctreaty.%0d%0a1%2c01+Mar+2004+MLJHB+-+PGMCHG2004-005+-+Novate+date+default+is+NULL%0d%0a0%2cNVL(to_char(Conv_Novate_Date%2c'YYYY-MM-DD')%2c%0d%0a0%2c'2003-12-01')%0d%0a1%2c23+Jul+2002+by+Debra+Linke+-+look+for+CNA+Plans+at+the+Treaty%0d%0a0%2clevel+ONLY%2c+so+ALL+Plans+will+be+updated+in+Trty_Plan_Proc.%0d%0a0%2c(Treaty_ID+%3d+%3aRRTB700-REC.Reference-ID%0d%0a0%2cAND++%3aRRTB700-Rec.Treaty-Plan-Code+%3d+'T')%0d%0a0%2cOR%0d%0a0%2c(Plan_ID+%3d+%3aRRTB700-REC.Reference-ID%0d%0a0%2cAND++%3aRRTB700-Rec.Treaty-Plan-Code+%3d+'P')%0d%0a1%2c23+Jul+2002+by+MLDIL+-+Routine+to+lookup+data+from+the%0d%0a0%2cAuto_Retro_Percent+table.%0d%0a0%2cInitialize+column%0d%0a1%2c07+Oct+03-MLJHB+-+Set+Null+Ind+for+'not+found'+condition.%0d%0a1%2c05+Jul+2007+by+D.Linke+-+PRGCHG2007-022.+Routine+to+lookup%0d%0a0%2cfrom+the+TREATY_ORD+TABLE.%0d%0a0%2cInitialize+column%0d%0a0%2cNo+Treaty+Part+%3a+Set+indicator+variables+to+NULL%0d%0a0%2cCheck+for+Treaty+Default+for+this+plan%0d%0a1%2cAdd+Benefit_Type+to+tpp+table+-+dlg+27+Aug+1999%0d%0a1%2c09+Mar+2000+by+Debra+Linke+-+Add+NAIC-Code+and+Comp-Fed-ID%0d%0a0%2cto+Trty_Plan_Proc+table+(from+Client_Company+table%2c+see%0d%0a0%2c2400-Read-Comp-Prof+para)%0d%0a1%2c25+May+2004+-+PGMCHG2004-021+-+MLJHB%3a+Add+XXX_IND+to%0d%0a0%2cTrty_Plan_Proc+from+Treaty_Char%0d%0a1%2c05+JUL+2007+by+D.Linke+-+PRGCHG2007-022+ADD+ZERO_FY_PREM_FLAG%0d%0a0%2cto+Trty_Plan_Proc+from+Treaty_Ord%0d%0a0%2cSet+Program+Controls+%26+Initialize+Data+as+needed%0d%0a0%2cadded+tkp-d++7+Jan+93...define+ending+date%0d%0a1%2ctrplREF_cursor+includes+all+trpl+ever+created%0d%0a0%2csome+plans+inadvertently+got+added+with+treaty+%3d+0%0d%0a0%2c(3690%2c3691%2c3770%2c3787%2c3788%2c3800%2c3827%2c3833%2c3975%2c3976%2c4151%2c4152)%0d%0a0%2cor+no+plan+general+(3986%2c4033%2c4145)%0d%0a0%2cTreaty+and+Group+(mlmlf+and+mlsam)+have+tried+to+fix+and%2for%0d%0a0%2cended+up+adding+a+new+plan+so+disregard+these+errors%0d%0a0%2cCan+also+disregard+errs+for+plans+eff+%3e%3d+ws-max-date%0d%0a0%2cckeller+28Aug98%0d%0a0%2cClear+out+previous+entries+for+this+month%0d%0a1%2cRead+Control+Card%3a+if+not+found%2c+use+defaults%0d%0a0%2cMove+control+card+Date+to+WS-Process-Date%0d%0a1%2c09+Oct+97+-+Baughman+-+Changes+for+Y2000+compliance.%0d%0a0%2cDefault+Mode%3a+find+the+current+SU+Activity+date+to+determine%0d%0a0%2cwhich+activity+date+to+bridge+backward%0d%0a0%2cDelete+Existing+Treaty%2fPlan+entries+for+this+date%0d%0a0%2cClose+Files+%26+Cursors%0d%0a0%2c'++Treaty+Plan+Code+'%2c%0d%0a0%2c'++Reference+ID+'%2c%0d%0a1%2cIF++SQLCODE+%3c+-900%0d%0a1%2cChanged+to+following+for+network....MLJB+-+09%2f18%2f95%0d%0a0%2cCall+ABEND+Routine+(ILBOABN0)%0d%0a0%2cCurrently%2c+do+NOT+invoke+DUMP%3b+code+left+in+case%0d%0a0%2cneeded+in+future.%0d%0a1%2cIF++ABEND-FLAG+%3d+'Y'%0d%0a0%2cCALL+ABEND-PROGRAM++USING++ABEND-CODE%0d%0a0%2cELSE%0d%0a0%2cMOVE++ABEND-CODE++TO++RETURN-CODE%0d%0a1%2cEND-IF.%0d%0a' Checked='False' Expanded='False' Target='0' Selected='False' />
<TreeNode ShapeId='6' ParentShapeID='5' Text='insert into trty_plan_proc' Value='Data' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP11R.PCO' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='7' ParentShapeID='5' Text='delete from  trty_plan_proc' Value='Data' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP11R.PCO' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='10' ParentShapeID='3' Text='SUIADJ
.BAT' Value='Process' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\SUNITED.bat' Tooltip='0%2c%0d%0a1%2cSUIADJ+-+Adjust+Inforce+Rows%0d%0a0%2c%0d%0a1%2c14+jan+2005+DLG++++++++++++++++++++Stop+printer+report+per+S.Elsey%0d%0a1%2c18+Feb+2004+MLJHB++PGMCHG2004-004++Change+report+file+name%0d%0a0%2c%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cSETOUTFILE.BAT+SU.P.INFADJ%0d%0a0%2cneeded+to+enable+output+redirection+and+block+'application+terminated'+popup+window%0d%0a1%2c14+jan+2005+dlg+stop+printing+report+per+S.+Elsey%0d%0a1%2cPRINT+REPORT+-+SUUP03R-01++++++++++++++++++%2f%0d%0a1%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cLOGMSG.BAT+0+%22CALL+LASERPRINT%3a+FILE%3dSUMMARY_INFORCE_ADJUST_DAILY%22%0d%0a1%2cCALL+LASERPRINT.BAT+%22FILE%3dSUMMARY_INFORCE_ADJUST_DAILY%7cPRT%3dSYSLJ%7cCLASS%3dM8%7cCPYS%3d4%22%0d%0a0%2cSET+RETCODE%3d%25ERRORLEVEL%25%0d%0a1%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cLOGMSG.BAT+0+%22END+LASERPRINT%3a+FILE%3dSUMMARY_INFORCE_ADJUST_DAILY%22+%25ERRORLEVEL%25%0d%0a0%2cset+retCode%3d0%0d%0a' Checked='False' Expanded='False' Target='0' Selected='False' />
<TreeNode ShapeId='16' ParentShapeID='10' Text='emptycrd
.CRD' Value='Card' ImageToolTip='c:\users\dad\documents\h-drive\bat_cis\run\crd\emptycrd.crd' Tooltip='' Checked='True' Expanded='False' Target='' Selected='False' />
<TreeNode ShapeId='11' ParentShapeID='16' Text='SUUP03R
.EXE' Value='Predefined process' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP03R.PCO' Tooltip='0%2cPD%0d%0a1%2cSUUP03R++-+SHORT+DESCRIPTION+++++++++++++++++++PROJ%23+6%0d%0a1%2cTHIS+PROGRAM+WILL+READ+THE+SUMMARY+INFORCE+TABLE+AND%0d%0a1%2cVERIFY+THAT+THE+YTD+INFORCE%2c+NEW+BUSINESS+AND+INCREASE%2fDECREAS%0d%0a0%2cNUMBERS+ARE+CORRECT+IN+EACH+ROW+OF+THE+TABLE.+IT+WILL+CHANGE+T%0d%0a1%2cINCREASE+DECREASE+TO+BALANCE+WITH+THE+INFORCE%2cIF+NECCESSARY%2c+A%0d%0a1%2cREPLACE+THAT+ROW+AND+DO+A+REPORT+OF+REPLACED+ROWS.%0d%0a0%2cIT+ALSO+THEN+CHECKS+THE+YTD+ROW+AND+MAKES+SURE+THE+DETAIL%0d%0a0%2cMATCHES+THE+TOTALS.%0d%0a0%2cNOTE+!!!!!!%0d%0a1%2cCONTROL+RECORD+CONTAINS+A+FLAG+TO+PREVENT+UPDATES+IF+YOU+JUST%0d%0a1%2cWANT+THE+REPORT.%0d%0a0%2cPROGRAM+HISTORY%3a%0d%0a0%2cDATE+++++BY++++PROJECT+%23++DESCRIPTION%0d%0a0%2c20+Jun+02+dlg+++++Expand+size+of+all+amount+fields+to+s9(12)%0d%0a0%2c22+May+00+JHB+++++Size+of+SUM-NEW-BUSINESS-AMT+increased%0d%0a0%2c30+Mar+98++ck+++++2400-REPL%3a+comment+display%0d%0a0%2c26+Feb+96+JHB+++++Commented+out+displays+to+reduce+output.%0d%0a0%2c26+APR+95+JHB+++++YTD-Indicator+changed+so+that+it+tests%0d%0a0%2ccorrectly+in+UPDATE+processing.%0d%0a0%2cSee+2400-%0d%0a0%2c24+APR+95+JHB+++++Check+SQLCODE+before+incrementing+counter+in%0d%0a0%2cUpdate+and+Insert+logic.%0d%0a0%2cChanged+during+downsizing+conversion.%0d%0a0%2c08+JUL+93++TKPD+++MAINT+++++ADD+VALUE+FUNCTIONS+FOR+SELECT+YTD%0d%0a0%2c%26+ADD+MORE+INFORMATION+TO+1010-%0d%0a0%2c22+JUL+92++TKPD+++MAINT+++++CORRECT+LOGIC+FOR+MOVE+TO+PREVIOUS%0d%0a1%2c06%2f21%2f91+++BH++++%23+6++++++++CREATE%0d%0a0%2c01++SUM-NEW-BUSINESS-AMT+++++++PIC+S9(11)V99++COMP-3+VALUE+%2b0.%0d%0a0%2cTABLE+DEFINITIONS%0d%0a0%2cINCLUDE+SUTB030_MLJB%0d%0a0%2cSQL+CURSORS%0d%0a0%2c26+Aug+1995++Luke+Balding++Added+Use+batch+rollback%0d%0a0%2cWE+READ+2+RECORDS+IN+HOUSEKEEPING%2c+BECAUSE+THE+FIRST+DETAIL%0d%0a0%2cRECORD++CANNOT+BE+BALANCED+TO+ANYTHING.%0d%0a1%2cALSO%2c+THERE+IS+A+CONTROL+RECORD+TO+DETERMINE+IF+UPDATES+SHOULD%0d%0a1%2cACTUALLY+BE+PERFORMED.+IF+THE+CONTROL+FILE+IS+EMPTY%2c+THE+DEFAU%0d%0a0%2cIS+YES.%0d%0a0%2cMOVE+SUTB030-REC+TO+PREV-INFORCE-REC.%0d%0a0%2cDISPLAY+'NEW+BUSINESS+AMOUNT+%3d+'%2c+NEW-BUSINESS-AMT++OF%0d%0a0%2cSUTB030-REC.%0d%0a0%2cMOVE+SUMMARY+INFORCE+TO+PREV+INFORCE+RECORD%0d%0a0%2cCALL+'ILBOABN0'+USING+ABEND-CODE.%0d%0a0%2cMOVE+SUTB030-REC+TO+PREV-INFORCE-REC.%0d%0a0%2cDISPLAY+'IN+YTD+TOTAL+CHECK+FOR+ID+%23+'+DIS-SUMM-ID.%0d%0a0%2cMAKE+SURE+THE+INFORCE+AMOUNTS+FOR+THE+YTD+RECORD+ARE+EQUAL%0d%0a0%2cTO+THE+LAST+DETAIL+FOR+THE+YEAR.%0d%0a0%2c%0d%0a0%2cREPLACES+THE+DETAIL+INFORCE+ROW.%0d%0a0%2cDISPLAY+'IN+REPLACE+INFORCE+FOR+'+P-SUMM-CONTROL-ID.%0d%0a0%2cCheck+SQLCODE+before+incrementing+counter.++Changed+during%0d%0a1%2cdownsizing+conversion.++++MLJB+-+24+APR+95%0d%0a0%2cCheck+SQLCODE+before+incrementing+counter.++Changed+during%0d%0a1%2cdownsizing+conversion.++++MLJB+-+24+APR+95%0d%0a0%2cCheck+SQLCODE+before+incrementing+counter.++Changed+during%0d%0a1%2cdownsizing+conversion.++++MLJB+-+24+APR+95%0d%0a1%2cIF+ANY+DETAIL+RECORDS+WERE+ADJUSTED%2c+SET+RETURN-CODE%0d%0a1%2cSO+REPORT+WILL+BE+PRINTED%0d%0a' Checked='False' Expanded='False' Target='0' Selected='False' />
<TreeNode ShapeId='12' ParentShapeID='11' Text='update summary_inforce' Value='Data' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP03R.PCO' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='13' ParentShapeID='11' Text='update summary_inforce' Value='Data' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP03R.PCO' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='14' ParentShapeID='11' Text='insert into  summary_inforce' Value='Data' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP03R.PCO' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='15' ParentShapeID='11' Text='summary_inforce_adjust_daily' Value='Document' ImageToolTip='' Tooltip='' Checked='False' Expanded='True' Target='' Selected='False' />
<TreeNode ShapeId='18' ParentShapeID='3' Text='SUIYTD
.BAT' Value='Process' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\SUNITED.bat' Tooltip='0%2c%0d%0a1%2cSUIYTD+-+Compute+YTD+Inforce+Rows%0d%0a0%2c%0d%0a1%2c18+Feb+04++MLJHB++PGMCHG2004-004++Change+report+file+names%0d%0a0%2c%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cSETOUTFILE.BAT+SU.P.INFYTD.RPT%0d%0a0%2cneeded+to+enable+output+redirection+and+block+'application+terminated'+popup+window%0d%0a' Checked='False' Expanded='False' Target='0' Selected='False' />
<TreeNode ShapeId='23' ParentShapeID='18' Text='emptycrd
.CRD' Value='Card' ImageToolTip='c:\users\dad\documents\h-drive\bat_cis\run\crd\emptycrd.crd' Tooltip='' Checked='True' Expanded='False' Target='' Selected='False' />
<TreeNode ShapeId='19' ParentShapeID='23' Text='SUUP08R
.EXE' Value='Predefined process' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP08R.PCO' Tooltip='0%2cPD%0d%0a1%2cSUUP08R++-+SHORT+DESCRIPTION+++++++++++++++++++PROJ%23+6%0d%0a1%2cTHIS+PROGRAM+WILL+CREATE+OR+UPDATE+YTD+INFORCE+ESTIMATE+ROWS.%0d%0a0%2cPROGRAM+HISTORY%3a%0d%0a0%2cDATE++BY+++PROJECT+%23++++++DESCRIPTION%0d%0a0%2c11+May+06+DIL++PRGCHG2006-037+NOTE%3a++This+change+is+for+the+'T'%0d%0a1%2cYTD+record+ONLY+-+did+not+do+'D'.++Users%0d%0a0%2crequest+to+generate+Estimates+earlier+in%0d%0a0%2cthe+month+has+required+us+to+change+the%0d%0a0%2cSQLs+so+we+DON'T+use+Estimates+of+FUTURE%0d%0a0%2cmonths+during+the+processing%3a%0d%0a0%2c1.+In+Inforce_Cursor+(SQL)%2c+changed+the%0d%0a0%2cWHERE+clause+to+use+'AND+Activity_Date%0d%0a0%2cBETWEEN+H-Start-Date+AND+H-Control-Date%0d%0a0%2cinstead+of+just+looking+at+the+YEAR+to%0d%0a0%2ckeep+from+getting+NEXT+months+entries.%0d%0a0%2c2.+In+2132-SUMM-YTD+(SQL)+para%2c+changed%0d%0a0%2cthe+WHERE+clause+to+use+'AND+Activity_%0d%0a0%2cDate+BETWEEN+H-Start-Date+AND+H-Control%0d%0a0%2c-Date+instead+of+just+the+YEAR+to+keep%0d%0a0%2cfrom+getting+NEXT+months+entries.%0d%0a0%2c3.+Added+H-Start-Date+and+WS-Start-Date+to%0d%0a0%2cWorking-Storage.%0d%0a0%2c4.+In+1000-Housekeep%2c+added+logic+to+move%0d%0a0%2cdata+into+WS-Start-Date.%0d%0a1%2c11+Feb+03+JHB++Maint+++If+nothing+is+selected+on+first+fetch%0d%0a1%2cof+Summary_Inforce+do+not+create+a+YTD%0d%0a0%2crow...First-Fetch+field+added+to+do+the%0d%0a0%2cchecking.%0d%0a0%2c20+JUN+02+DLG++++++++++EXPAND+ALL+AMOUNT+FIELD+TO+S9(12).%0d%0a0%2c22+apr+99+dlg++++++++++add+display+of+WS-CNTL-UPDATES+at+eoj.%0d%0a1%2cmodified+1000-HOUSEKEEP+to+set+report%0d%0a1%2cline+switch+off+if+update+not+Y.%0d%0a0%2c08+Oct+97+JHB+++Maint++Changes+for+Y2000+compliance%3a%0d%0a0%2c%3d%3d%3e+WS-CNTL-RECORD%0d%0a0%2c%3d%3d%3e+1000-HOUSEKEEP%0d%0a0%2c27+JAN+95+DIT+++DOWNSIZE+++DUAL+MAINTENANCE+ON+26+JAN+95+CHANGE%0d%0a0%2cIN+1000-HOUSEKEEP+PARA.%0d%0a0%2c26+JAN+95+DLG+++MAINT++CHANGE+SETUP+FOR+PREV-YEAR.++ADD+DISPLAY%0d%0a0%2cFOR+YEARS+USED.%0d%0a0%2c26+FEB+93+TKPD++MAINT++CORRECT+YTD+SUMMARY+PROCESS%0d%0a0%2c12+AUG+92+TKPD++MAINT++CORRECT+SELECT+YTD+CURSOR+TO+ALLOW+FOR%0d%0a0%2cNULLS.%0d%0a1%2c01%2f14%2f92++BH++++%23+6++++CREATE%0d%0a1%2c11+May+2006+by+DIL+-+PRGCHG2006-037%0d%0a0%2c02-11-03+JHB++Check+for+no+input+on+first+fetch.%0d%0a1%2c08+Oct+97+-+Baughman+-+Change+for+Y2000+compliance.%0d%0a0%2c07++WS-CNTL-YY++++++PIC+X(2)+++VALUE+SPACES.%0d%0a0%2c07++FILLER++++++++++PIC+X(8)+++VALUE+SPACES.%0d%0a1%2c11+May+2006+BY+DIL+-+PRGCHG2006-034+-+Changed+to+use+entire%0d%0a0%2cDate+instead+of+just+the+year.%0d%0a0%2c01++WS-FORMAT-YEAR.%0d%0a0%2c05++WS-FMT-CC+++++++++++PIC+XX+++++VALUE+'19'.%0d%0a0%2c05++WS-FMT-YY+++++++++++PIC+99+++++VALUE++ZEROES.%0d%0a0%2c15++P-ACTIVITY-YEAR+++PIC+X(4)+VALUE+SPACES.%0d%0a0%2c15++FILLER++++++++++++PIC+X(6)+VALUE+SPACES.%0d%0a0%2cTABLE+DEFINITIONS%0d%0a0%2cSQL+CURSORS%0d%0a1%2c11+May+2006+by+DIL+-+PRGCHG2006-037%0d%0a0%2cAND+SUBSTR(TO_CHAR(ACTIVITY_DATE)%2c1%2c4)+%3d+%3aCONTROL-YEAR%0d%0a0%2c26+Aug+1995++Luke+Balding++Added+Use+batch+rollback%0d%0a1%2c11+May+2006+BY+DIL+-+PRGCHG2006-037+-+We+are+using+the%0d%0a0%2cwhole+date+NOT+just+the+year+now%0d%0a1%2c08+Oct+97+-+Baughman+-+Change+for+Y2000+compliance.%0d%0a0%2cSUBTRACT+1+FROM+WS-FMT-YY.%0d%0a0%2cMOVE++WS-FORMAT-YEAR+++TO+PREV-YEAR.%0d%0a1%2c11+May+2006+by+DIL+-+PRGCHG2006-037%0d%0a0%2cCALL+'ILBOABN0'+USING+ABEND-CODE%0d%0a1%2c-+DUALMAINT1+BELOW+-+26+JAN+95+-+DLG%0d%0a1%2c02-11-03+JHB++If+nothing+is+selected+on+first+fetch%0d%0a1%2cof+Summary_Inforce+do+not+create+a+YTD%0d%0a0%2crow...there+is+nothing+to+update.%0d%0a0%2cMOVE+SUTB030-REC+TO+PREV-INFORCE-REC.%0d%0a1%2cmodified+to+set+report+line+switch+off+if+update+not+Y+-+dlg+22+Apr+99%0d%0a1%2cIF+++WS-CNTL-UPDATES+%3d+'N'%0d%0a0%2ctemporary+displays+to+track+nibble+error%0d%0a1%2cmljb+-+2+dec+97%0d%0a0%2cCALL+'ILBOABN0'+USING+ABEND-CODE.%0d%0a0%2cMOVE+SUTB030-REC+TO+PREV-INFORCE-REC.%0d%0a1%2c11+May+2006+by+DIL+-+PRGCHG2006-037%0d%0a0%2c(SUBSTR(to_CHAR(ACTIVITY_DATE)%2c1%2c4)+%3d+%3aCONTROL-YEAR%0d%0a0%2cMAKE+SURE+THE+INFORCE+AMOUNTS+FOR+THE+YTD+RECORD+ARE+EQUAL%0d%0a0%2cTO+THE+LAST+DETAIL+FOR+THE+YEAR.%0d%0a0%2c%0d%0a0%2c02-11-2003+JHB++Check+First-Fetch+to+bypass+creating+YTD+row.%0d%0a' Checked='False' Expanded='False' Target='0' Selected='False' />
<TreeNode ShapeId='20' ParentShapeID='19' Text='update summary_inforce' Value='Data' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP08R.PCO' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='21' ParentShapeID='19' Text='insert into  summary_inforce' Value='Data' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP08R.PCO' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='22' ParentShapeID='19' Text='summary_inforce_est_ytd_daily' Value='Document' ImageToolTip='' Tooltip='' Checked='False' Expanded='True' Target='' Selected='False' />
<TreeNode ShapeId='25' ParentShapeID='3' Text='SUPADJ
.BAT' Value='Process' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\SUNITED.bat' Tooltip='0%2c%0d%0a0%2cSUPADJ+Compute+YTD+Premium+Rows%0d%0a0%2c%0d%0a1%2c18+Feb+04++MLJHB++PGMCHG2004-004++Change+Report+file+names%0d%0a0%2c%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cSETOUTFILE.BAT+SU.P.PRMADJ.RPT%0d%0a0%2cneeded+to+enable+output+redirection+and+block+'application+terminated'+popup+window%0d%0a' Checked='False' Expanded='False' Target='0' Selected='False' />
<TreeNode ShapeId='30' ParentShapeID='25' Text='emptycrd
.CRD' Value='Card' ImageToolTip='c:\users\dad\documents\h-drive\bat_cis\run\crd\emptycrd.crd' Tooltip='' Checked='True' Expanded='False' Target='' Selected='False' />
<TreeNode ShapeId='26' ParentShapeID='30' Text='SUUP04R
.EXE' Value='Predefined process' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP04R.PCO' Tooltip='0%2cPD%0d%0a1%2cSUUP04R++-+SHORT+DESCRIPTION+++++++++++++++++++PROJ%23+7%0d%0a1%2cTHIS+PROGRAM+WILL+READ+THE+SUMMARY+PREMIUM+TABLE+AND%0d%0a1%2cVERIFY+THAT+THE+DETAIL+ROWS+ADD+UP+TO+EQUAL+THE+YTD+ROWS.+IF%0d%0a1%2cTHEY+ARE+UNEQUAL%2c+OR+IF+A+YTD+ROW+MUST+BE+CREATED%2c+IT+WILL%0d%0a1%2cREPLACE+OR+ADD+THE+ROW+AND+REPORT+IT.+FOR+THE+ESTIMATE+YTD%0d%0a0%2cROWS+IT+WILL+CALCULATE+THE+CURRENT+BALANCE+DUE%3b+FOR+ACTUALS%0d%0a0%2cTHE+YTD+IS+JUST+A+TOTAL+OF+THE+DETAIL.%0d%0a0%2cPROGRAM+HISTORY%3a%0d%0a0%2cDATE++++BY+++PROJECT+%23++++++DESCRIPTION%0d%0a0%2c11+May+06+DIL++PRGCHG2006-037+NOTE%3a++This+change+is+for+the+'T'%0d%0a1%2cYTD+record+ONLY+-+did+not+do+'D'.++Users%0d%0a0%2crequest+to+generate+Estimates+earlier+in%0d%0a0%2cthe+month+has+required+us+to+change+the%0d%0a0%2cSQLs+so+we+DON'T+use+future+months+Esti-%0d%0a0%2cmates+during+the+processing%3a%0d%0a0%2c1.+In+Prem_Input_Cursor+(SQL)%2c+changed+the%0d%0a0%2cWHERE+clause+to+use+'AND+Activity_Date%0d%0a0%2cBETWEEN+H-Start-Date+AND+H-Control-Date%0d%0a0%2cinstead+of+just+looking+at+the+YEAR.%0d%0a0%2cThis+will+keep+from+getting+the+NEXT%0d%0a0%2cmonths+Estimate+entries.%0d%0a0%2c2.+In+2150-Curr-Bal-Due+(SQL)+para%2c+changed%0d%0a0%2cthe+WHERE+clause+to+use+'AND+Activity_%0d%0a0%2cDate+BETWEEN+H-Start-Date+AND+H-Control%0d%0a0%2c-Date+instead+of+the+YEAR+to+keep+from%0d%0a0%2cgetting+NEXT+months+entries.%0d%0a0%2c3.+Added+H-Start-Date+and+WS-Start-Date+to%0d%0a0%2cWorking-Storage.%0d%0a0%2c4.+In+1000-Housekeep%2c+added+logic+to+move%0d%0a0%2cdata+into+WS-Start-Date.%0d%0a0%2c25+Mar+04+JHB++PRGCHG2004-008+Correct+PREM_INPUT_CURSOR+FETCH%0d%0a0%2cin+1001-READ-PREMIUM-INPUT+by+adding%0d%0a0%2cER-NR-IND.%0d%0a0%2cCorrect+DISPLAY+when+SQLCODE+not+%3d+%2b0.%0d%0a0%2cCorrect+2150-CURR-BAL-DUE+select.%0d%0a0%2c25+Mar+04+JHB++Note%3a++See+changes+related+to+PRGCHG2004--008.%0d%0a0%2cIn+the+case+where+SUTB040-REC.ER-NR-CODE%0d%0a0%2cis+NULL%2c+the+WHERE+clause+will+fail+and%0d%0a0%2cgive+a+SQLCODE+code+%3d+100.++Most+likely%0d%0a0%2ca+YTD+row+with+a+valid+ER_NR_CODE+already%0d%0a0%2cexists+and+the+program+will+fail+at+2410-%0d%0a0%2cINSERT-NEW-YTD+with+a+unique+constraint%0d%0a0%2cerror.++The+ER_NR_CODE+in+the+detail+row%0d%0a1%2cmust+be+corrected+for+the+program+to+run.%0d%0a0%2cER_NR_CODE+should+have+been+declared+NOT%0d%0a0%2cNULL+from+the+beginning%2c+but+this+error%0d%0a0%2chappens+only+rarely.%0d%0a0%2c31+Mar+98++ck++maint++1010-SQL-ERR%3a+add+displays%0d%0a0%2c07+Oct+97+JHB++Maint++Changes+for+Y2000+compliance%3a%0d%0a0%2c%3d%3d%3e+1000-HOUSEKEEP%0d%0a0%2c04+Mar+93+tkpd+maint++work+on+various+bugs%0d%0a1%2c07%2f31%2f91++BH++++%23+7+++CREATE%0d%0a1%2c07+Oct+97+-+Baughman+-+Change+for+Y2000+compliance.%0d%0a0%2c05++CONTROL-YY++++++++++++PIC+99+++++VALUE+0.%0d%0a0%2c01++WS-FORMAT-YEAR.%0d%0a0%2c05++FORMAT-CC+++++++++++++PIC+99+++++VALUE+19.%0d%0a0%2c05++FORMAT-YY+++++++++++++PIC+99+++++VALUE+0.%0d%0a0%2cTABLE+DEFINITIONS%0d%0a0%2cSQL+CURSORS%0d%0a0%2cTHIS+CURSOR+WILL+GIVE+US+ONE+ROW+FOR+EACH+TYPE+OF+PREMIUM+FOR%0d%0a0%2cACTUALS+OR+ESTIMATES+FOR+EACH+YEAR.+WE+WILL+USE+THIS+TO+SUM%0d%0a0%2cALL+THE+PREMIUM+OF+THIS+TYPE+FOR+THE+YEAR+AND+COMPARE+IT%0d%0a0%2cTO+THE+YTD+ROW.%0d%0a1%2c11+May+2006+by+DIL+-+use+the+full+Activity_Date+and+full%0d%0a0%2cControl-Date+INSTEAD+OF+the+Activity_Year+and+Control-Year%0d%0a1%2c11+May+2006+-+DIL+-+PRGCHG2006-037%0d%0a1%2c11+May+2006+-+DIL+-+PRGCHG2006-037%0d%0a0%2cAND+SUBSTR(TO_CHAR(ACTIVITY_DATE)%2c1%2c4)+%3d+%3aCONTROL-YEAR%0d%0a0%2c26+Aug+1995++Luke+Balding++Added+Use+batch+rollback%0d%0a1%2c11+May+2006+by+DIL+-+PRGCHG2006-037+-+use+entire+Date%2c+not%0d%0a0%2cjust+the+Year.%0d%0a1%2c11+May+2006+by+DIL+-+PRGCHG2006-037%0d%0a1%2c11+May+2006+by+DIL+-+PRGCHG2006-037%0d%0a1%2c25+Mar+04+-+JHB+-+PGMCHG2004-008%0d%0a1%2cIF+SQLCODE+%3d+%2b0%0d%0a0%2cNEXT+SENTENCE%0d%0a1%2c25+Mar+04+-+JHB+-+PGMCHG2004-008%0d%0a0%2cDISPLAY+'Read+in+Summ+Control+ID+'%2c%0d%0a1%2c03+Oct+97+-+Baughman+-+Changes+for+Year+2000%0d%0a0%2cCALL+'ILBOABN0'+USING+ABEND-CODE.%0d%0a0%2cCALL+'ILBOABN0'+USING+ABEND-CODE.%0d%0a0%2cAND+(ACTIVITY_TYPE+%3d+%3aSUTB040-REC.ACTIVITY-TYPE+OR%0d%0a0%2cACTIVITY_TYPE+%3d+%3aADJ-ACTIVITY-TYPE+)%0d%0a0%2cCURRENT+BALANCE+DUE+IS+THE+SUM+OF+ESTIMATES+(OUTSTANDING)+FOR+TH%0d%0a0%2cYEAR+PLUS+THE+CURRENT+BAL+DUE+FROM+LAST+YEAR.%0d%0a0%2c'OUTSTANDING'+ESTIMATES+ARE+JUST+THE+TOTAL+OF+THE+ESTIMATE+DETAI%0d%0a0%2cSINCE+REVERSALS+ARE+INCLUDED.%0d%0a1%2c11+May+2006+by+DIL+-+use+the+full+Activity_Date+INSTEAD+OF+the%0d%0a0%2cActivity_Year.%0d%0a1%2c25+Mar+04+-+JHB+-+PGMCHG2004-008%0d%0a0%2cSUM(PREMIUM_AMT)%0d%0a1%2c11+May+2006+-+DIL+-+PRGCHG2006-037%0d%0a0%2cAND+SUBSTR(TO_CHAR(ACTIVITY_DATE)%2c1%2c4)+%3d%0d%0a0%2c%3aACTIVITY-YEAR%0d%0a1%2c25+Mar+04+-+JHB+-+PGMCHG2004-008%0d%0a0%2cAND+ER_NR_CODE++++%3d++++%3aSUTB040-REC.ER-NR-CODE%0d%0a1%2c25+Mar+04+-+JHB+-+PRGCHG2004-008%0d%0a0%2cAND+ER_NR_CODE++++%3d++++%3aSUTB040-REC.ER-NR-CODE%0d%0a0%2cDISPLAY+'++CBD+%3d%3d%3d%3e+'%2c%0d%0a0%2cSUM-PREMIUM-AMT.%0d%0a1%2c25+Mar+2004+-+JHB+-+Note%3a++See+changes+related+to%0d%0a0%2cPGMCHG2004-008.++In+the+case+where+SUTB040-REC.ER-NR-CODE+is%0d%0a0%2cNULL%2c+the+WHERE+clause+will+fail+and+give+a+SQLCODE+%3d+100.%0d%0a0%2cMost+likely+a+YTD+row+with+a+valid+ER_NR_CODE+already+exists%0d%0a0%2cand+the+program+will+fail+at+2410-INSERT-NEW-YTD+with+a%0d%0a0%2cunique+constraint+error.++The+ER_NR_CODE+in+the+detail+row%0d%0a1%2cmust+be+corrected+for+the+program+to+run.++The+ER_NR_CODE%0d%0a0%2cshould+have+been+declared+NOT+NULL+from+the+beginning%2c+but%0d%0a0%2cthis+error+happens+only+rarely.%0d%0a1%2cDISPLAY+'+Get+YTD+Row+-+YTD+Prem+%3d+'%2c%0d%0a0%2cYTD-Premium-Amt%2c+'+SQLCode+%3d+'%2c+SQLCODE.%0d%0a0%2cDISPLAY+'++2300-COMPARE-AMTS+'%2c%0d%0a0%2c'+YTD+%3d+'%2c+YTD-Premium-Amt%2c%0d%0a0%2c'+Sum+%3d+'%2c+SUM-Premium-Amt.%0d%0a0%2cEXEC+SQL%0d%0a0%2cSELECT+MAX(CONTROL_VNUM)%0d%0a0%2cINTO+%3aSUTB040-REC.CONTROL-VNUM%0d%0a0%2cFROM+SUMMARY_PREMIUM%0d%0a0%2cWHERE+SUMM_CONTROL_ID+%3d+%3aSUTB040-REC.SUMM-CONTROL-ID%0d%0a0%2cAND+YTD_INDICATOR+%3d++'+'%0d%0a0%2cAND+(ACTIVITY_TYPE+%3d+%3aSUTB040-REC.ACTIVITY-TYPE%0d%0a0%2cOR++ACTIVITY_TYPE+%3d+%3aADJ-ACTIVITY-TYPE+)%0d%0a0%2cAND+SUBSTR(TO_CHAR(ACTIVITY_DATE)%2c1%2c4)+%3d+%3aACTIVITY-YEAR%0d%0a0%2cAND+ER_NR_CODE++++%3d++++%3aSUTB040-REC.ER-NR-CODE%0d%0a0%2cAND+FACTOR_TYPE+++%3d++++%3aSUTB040-REC.FACTOR-TYPE%0d%0a0%2cAND+FACTOR_USE++++%3d++++%3aSUTB040-REC.FACTOR-USE%0d%0a0%2cAND+BENEFIT_TYPE++%3d++++%3aSUTB040-REC.BENEFIT-TYPE%0d%0a0%2cAND+PREM_COMM_DUR+%3d++++%3aSUTB040-REC.PREM-COMM-DUR%0d%0a0%2cEND-EXEC.%0d%0a0%2cPERFORM+1010-SQL-ERROR-CHECK+THRU+1010-EXIT.%0d%0a' Checked='False' Expanded='False' Target='0' Selected='False' />
<TreeNode ShapeId='27' ParentShapeID='26' Text='update summary_premium' Value='Data' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP04R.PCO' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='28' ParentShapeID='26' Text='insert into summary_premium' Value='Data' ImageToolTip='C:\Users\Dad\Documents\L-Drive\COB_2000\COMPILE\SOURCE\SUUP04R.PCO' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='29' ParentShapeID='26' Text='summary_payment_adjust_daily' Value='Document' ImageToolTip='' Tooltip='' Checked='False' Expanded='True' Target='' Selected='False' />
<TreeNode ShapeId='32' ParentShapeID='1' Text='REFRESH.ADHOC
.BAT' Value='Process,9' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' Tooltip='0%2cREFRESH.ADHOC.CMD%0d%0a0%2c%0d%0a1%2cpowerjob+%2fPROC%3aREFRESH.ADHOC.CMD+%2fSRV%3aGRACEPRO%0d%0a1%2c12+May+2003++YSH+Modified+to+call+GEC_Snapshot_Refresh.sql%0d%0a0%2c03+June+2003+YSH+Added+call+to+Refresh+Claims+Query+Table%0d%0a0%2c%0d%0a0%2ctrace+r%0d%0a0%2c%0d%0a0%2cRefresh+Snapshots%0d%0a0%2c%0d%0a0%2c%0d%0a0%2cRefresh+Claims+Query+Table%0d%0a0%2c%0d%0a' Checked='False' Expanded='False' Target='_top' Selected='False' />
<TreeNode ShapeId='33' ParentShapeID='32' Text='GEC_SNAPSHOT_REFRESH
.SQL' Value='Stored Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\GEC_SNAPSHOT_REFRESH.SQL' Tooltip='' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='34' ParentShapeID='32' Text='TEMP_CLAIM_REFRESH
.SQL' Value='Stored Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\TEMP_CLAIM_REFRESH.SQL' Tooltip='1%2c%40Q%3a%5cBat_Cis%5cRUN%5cSQL%5cTemp_Claim_Refresh.sql%0d%0a1%2cspool+logs%5ctemp_claim_refresh.log%0d%0a' Checked='False' Expanded='False' Target='0' Selected='False' />
<TreeNode ShapeId='35' ParentShapeID='34' Text='drop table claim_detail_lib_amt_c1' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\TEMP_CLAIM_REFRESH.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='36' ParentShapeID='34' Text='create table claim_detail_lib_amt_c1' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\TEMP_CLAIM_REFRESH.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='37' ParentShapeID='1' Text='GCTRPL
.BAT' Value='Process,12' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' Tooltip='0%2c%0d%0a0%2cGCTRPL.cmd%0d%0a1%2cThis+program+creates+daily+tables%2fviews+for+group.%0d%0a0%2c%0d%0a0%2c23+Apr+2004++dlg+++Remove+refreshs+to+ADHOC%0d%0a1%2c07+JUN+1999++MJD+++Created%0d%0a0%2c20+apr+2000++dlg+++changed+symbolic+path+to+point+to%0d%0a0%2cproduction+version+(q%3a%5csrv%5csqlplus)%0d%0a0%2c06+apr+2004+YSH%09++Added+to+run+the+same+refresh+on+victor%0d%0a0%2c%0d%0a1%2cPOWERJOB+%2fPROC%3aGCTRPL.cmd+%2fPRI%3a2+%2fSRV%3aGRACE+%2flog%3autil%0d%0a0%2cset+local%3dadhoc%0d%0a0%2cpath%3d'%5c%5catls000107%5cgecj%5csqlplus%5c'%0d%0a0%2cset+localPath%3d%5c%5cgrace%5cqdisk%5csrv%5csqlplus%5c%0d%0a0%2cSET+SQLPATH%3d%40%25LOCALPATH%25GCTRPL.SQL%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cLOGMSG+0+%22BEGIN+GCTRPL.SQL%40ADHOC%22%0d%0a0%2cSQLPLUS+GRP%2fGRP+%40C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cRUN%5cSQL%5cGCTRPL.SQL+%3e%3e+%25BATLOGS%25%251_%25CURDD%25-%25CURMON%25-%25CURYYYY%25_%25CURHH%25.%25CURMIN%25.%25CURSEC%25.%25CURMSEC%25.LOG+2%3e%261%0d%0a0%2cSET+RETCODE%3d%25ERRORLEVEL%25%0d%0a0%2cCALL+C%3a%5cUSERS%5cDAD%5cDOCUMENTS%5cH-DRIVE%5cBAT_CIS%5cINCLUDE%5cLOGMSG+1+%22END+GCTRPL.SQL%40ADHOC%22+%25ERRORLEVEL%25%0d%0a' Checked='False' Expanded='False' Target='_top' Selected='False' />
<TreeNode ShapeId='38' ParentShapeID='37' Text='GCTRPL
.SQL' Value='Stored Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\GCTRPL.SQL' Tooltip='1%2cFor+all+months+the+activity+date+will+agree+with+the+current%0d%0a1%2cmonth+with+the+exception+of%3a+March%2c+June%2c+September+and+December.%0d%0a1%2cAfter+these+months+the+activity+date+will+have+to+reflect+the%0d%0a1%2cprevious+month+for+15+days+(i.e++July+1+-+15+will+still+have+the%0d%0a1%2cactivity+date+JUN_99)+following+the+same+pattern+as+the+SU+cycle.%0d%0a1%2c07-JUN-1999++MJD%0d%0a1%2c20-apr-2000++dlg++replace+hardcopy+dates+with+join+of+su+control%0d%0a1%2cdate%0d%0a1%2c31-dec-2002++dlg++add+primary_treaty_id+gctrpl%3b+add+primary_treaty_id%2c%0d%0a1%2ctreaty_id%2c+and+primary_plan_id+to+gcprem%2c+and+gcif.%0d%0a1%2c27-jan-2005++dlg++add+prem_comm_dur+to+GCPREM+and+remove+account_suffix.%0d%0a1%2c27-Feb-2007++dlg++add+factor_use+to+GCPREM%0d%0a1%2c03-dec-2007++dlg++add+PC+to+as_lob+to+pickup+the+IUI+business%0d%0a' Checked='False' Expanded='False' Target='0' Selected='False' />
<TreeNode ShapeId='39' ParentShapeID='38' Text='truncate table gctrpl' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\GCTRPL.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='40' ParentShapeID='38' Text='truncate table gcprem' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\GCTRPL.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='41' ParentShapeID='38' Text='truncate table gcif' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\GCTRPL.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='42' ParentShapeID='38' Text='insert into gctrpl ' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\GCTRPL.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='43' ParentShapeID='38' Text='insert into gcprem' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\GCTRPL.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='44' ParentShapeID='38' Text='insert into gcif' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\GCTRPL.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='45' ParentShapeID='1' Text='WRR_CANCEL_NOTIFICATION_SQL
.BAT' Value='Process,15' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' Tooltip='1%2c%2f+Run+WinRiskRE+Cancel+Notification+SQL%0d%0a0%2cexit%0d%0a0%2c%0d%0a1%2cPOWERJOB+%2fPROC%3aWRR_CANCEL_NOTIFICATION_SQL.CMD+%2fPRI%3a5+%2fLOG%3aSU+%2fSRV%3aGRACE%0d%0a0%2c%0d%0a0%2cCOMMAND+FILE+TO+execute+a+WinRiskRe+compiled+sql+procedure%0d%0a0%2cto+setup+for+the+120+day+Cancelation%0d%0a1%2cNotification+Process%0d%0a1%2c17+Jul+2002+-+Gandy++modify+say+connect+to+show+how+connected.%0d%0a1%2c21+Mar+2000+-+Gandy%0d%0a0%2c%2f%0d%0a' Checked='False' Expanded='False' Target='_top' Selected='False' />
<TreeNode ShapeId='46' ParentShapeID='45' Text='EXECUTE_WRR_CANCEL_NOTIFICATION
.SQL' Value='Stored Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\EXECUTE_WRR_CANCEL_NOTIFICATION.SQL' Tooltip='1%2cthis+will+execute+a+WinRiskRe+sql+procedure+which+has%0d%0a1%2cbeen+compiled+into+the+WinRiskRe+database%0d%0a1%2csets+up+for+the+120+day+cancellation+notification+process%0d%0a1%2cexit%0d%0a' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='47' ParentShapeID='1' Text='CleanUp_Processes
.BAT' Value='Process,18' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' Tooltip='0%2c%0d%0a0%2cCleanUp+Orphaned+Processes%0d%0a0%2c%0d%0a0%2c%0d%0a1%2c23+June+2003++YSH+Created+to+call+CleanUp+Orphaned+Processes.sql%0d%0a0%2c%0d%0a0%2c%0d%0a0%2ctrace+r%0d%0a0%2c%0d%0a0%2cCleanUp+Orphaned+Processes%0d%0a0%2c%0d%0a' Checked='False' Expanded='False' Target='_top' Selected='False' />
<TreeNode ShapeId='48' ParentShapeID='47' Text='CLEANUP_ORPHANED_PROCESSES
.SQL' Value='Stored Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\CLEANUP_ORPHANED_PROCESSES.SQL' Tooltip='' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='49' ParentShapeID='47' Text='CALLORAKILL
.BAT' Value='Process' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\CleanUp_Processes.bat' Tooltip='' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='50' ParentShapeID='1' Text='REFRESH.VICTOR
.BAT' Value='Process,21' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' Tooltip='0%2c%0d%0a0%2cREFRESH.VICTOR.CMD%0d%0a0%2c%0d%0a1%2cpowerjob+%2fPROC%3aREFRESH.VICTOR.CMD+%2fSRV%3aGRACEPRO%0d%0a1%2c21+October+2003++YSH+Created+to+refresh+materilized+views%0d%0a0%2ccall+VICTOR_Snapshot_Refresh.sql%0d%0a0%2c%0d%0a0%2c%0d%0a0%2cRefresh+Snapshots%0d%0a0%2c%0d%0a' Checked='False' Expanded='False' Target='_top' Selected='False' />
<TreeNode ShapeId='51' ParentShapeID='50' Text='VICTOR_SNAPSHOT_REFRESH
.SQL' Value='Stored Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\VICTOR_SNAPSHOT_REFRESH.SQL' Tooltip='' Checked='False' Expanded='False' Target='0' Selected='False' />
<TreeNode ShapeId='52' ParentShapeID='51' Text='delete from config' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\VICTOR_SNAPSHOT_REFRESH.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='53' ParentShapeID='51' Text='insert into config ' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\VICTOR_SNAPSHOT_REFRESH.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='54' ParentShapeID='51' Text='insert into config ' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\VICTOR_SNAPSHOT_REFRESH.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='55' ParentShapeID='51' Text='insert into config ' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\VICTOR_SNAPSHOT_REFRESH.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='56' ParentShapeID='51' Text='insert into config ' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\VICTOR_SNAPSHOT_REFRESH.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='57' ParentShapeID='51' Text='insert into config ' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\VICTOR_SNAPSHOT_REFRESH.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='58' ParentShapeID='51' Text='insert into config ' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\VICTOR_SNAPSHOT_REFRESH.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='59' ParentShapeID='51' Text='insert into config ' Value='Data' ImageToolTip='C:\USERS\DAD\DOCUMENTS\H-DRIVE\BAT_CIS\RUN\SQL\VICTOR_SNAPSHOT_REFRESH.SQL' Tooltip='+' Checked='False' Expanded='True' Target='0' Selected='False' />
<TreeNode ShapeId='60' ParentShapeID='1' Text='CLEARVARS
.BAT' Value='Process,24' ImageToolTip='C:\Users\Dad\Documents\H-Drive\Bat_Cis\RUN\daily.bat' Tooltip='' Checked='False' Expanded='True' Target='' Selected='False' />
<TreeNode ShapeId='61' ParentShapeID='1' Text='End' Value='Terminator,26' ImageToolTip='' Tooltip='' Checked='False' Expanded='True' Target='' Selected='False' />
</TreeView>
</FileStats>